Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 23906 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 3.6 MiB |
| Average record size in memory | 156.0 B |
Variable types
| Text | 3 |
|---|---|
| DateTime | 1 |
| Categorical | 10 |
| Numeric | 7 |
Amount_paid_for_insurance is highly overall correlated with Price_($) | High correlation |
Dealer_Name is highly overall correlated with Dealer_No | High correlation |
Dealer_No is highly overall correlated with Dealer_Name | High correlation |
Engine is highly overall correlated with Transmission | High correlation |
Price_($) is highly overall correlated with Amount_paid_for_insurance | High correlation |
Transmission is highly overall correlated with Engine | High correlation |
Car_id has unique values | Unique |
Claim_amount has 21516 (90.0%) zeros | Zeros |
Reproduction
| Analysis started | 2024-05-30 10:59:32.393720 |
|---|---|
| Analysis finished | 2024-05-30 11:00:20.716925 |
| Duration | 48.32 seconds |
| Software version | ydata-profiling v4.8.3 |
| Download configuration | config.json |
Car_id
Text
UNIQUE 
| Distinct | 23906 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 186.9 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Characters and Unicode
| Total characters | 286872 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 23906 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | C_CND_000001 |
|---|---|
| 2nd row | C_CND_000002 |
| 3rd row | C_CND_000003 |
| 4th row | C_CND_000004 |
| 5th row | C_CND_000005 |
| Value | Count | Frequency (%) |
| c_cnd_000001 | 1 | < 0.1% |
| c_cnd_000014 | 1 | < 0.1% |
| c_cnd_000005 | 1 | < 0.1% |
| c_cnd_000006 | 1 | < 0.1% |
| c_cnd_000007 | 1 | < 0.1% |
| c_cnd_000008 | 1 | < 0.1% |
| c_cnd_000009 | 1 | < 0.1% |
| c_cnd_000010 | 1 | < 0.1% |
| c_cnd_000011 | 1 | < 0.1% |
| c_cnd_000046 | 1 | < 0.1% |
| Other values (23896) | 23896 |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 47812 | |
| _ | 47812 | |
| 0 | 44089 | |
| N | 23906 | |
| D | 23906 | |
| 1 | 20181 | |
| 2 | 14088 | 4.9% |
| 3 | 10088 | 3.5% |
| 5 | 9181 | 3.2% |
| 4 | 9181 | 3.2% |
| Other values (4) | 36628 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 286872 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 47812 | |
| _ | 47812 | |
| 0 | 44089 | |
| N | 23906 | |
| D | 23906 | |
| 1 | 20181 | |
| 2 | 14088 | 4.9% |
| 3 | 10088 | 3.5% |
| 5 | 9181 | 3.2% |
| 4 | 9181 | 3.2% |
| Other values (4) | 36628 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 286872 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 47812 | |
| _ | 47812 | |
| 0 | 44089 | |
| N | 23906 | |
| D | 23906 | |
| 1 | 20181 | |
| 2 | 14088 | 4.9% |
| 3 | 10088 | 3.5% |
| 5 | 9181 | 3.2% |
| 4 | 9181 | 3.2% |
| Other values (4) | 36628 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 286872 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 47812 | |
| _ | 47812 | |
| 0 | 44089 | |
| N | 23906 | |
| D | 23906 | |
| 1 | 20181 | |
| 2 | 14088 | 4.9% |
| 3 | 10088 | 3.5% |
| 5 | 9181 | 3.2% |
| 4 | 9181 | 3.2% |
| Other values (4) | 36628 |
Date
Date
| Distinct | 612 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 186.9 KiB |
| Minimum | 2022-01-02 00:00:00 |
|---|---|
| Maximum | 2023-12-31 00:00:00 |
Customer_Name
Text
| Distinct | 3022 |
|---|---|
| Distinct (%) | 12.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 186.9 KiB |
Length
| Max length | 16 |
|---|---|
| Median length | 15 |
| Mean length | 5.8355643 |
| Min length | 1 |
Characters and Unicode
| Total characters | 139505 |
|---|---|
| Distinct characters | 55 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1169 ? |
|---|---|
| Unique (%) | 4.9% |
Sample
| 1st row | Geraldine |
|---|---|
| 2nd row | Gia |
| 3rd row | Gianna |
| 4th row | Giselle |
| 5th row | Grace |
| Value | Count | Frequency (%) |
| thomas | 92 | 0.4% |
| emma | 91 | 0.4% |
| lucas | 88 | 0.4% |
| nathan | 80 | 0.3% |
| louis | 77 | 0.3% |
| lea | 76 | 0.3% |
| chloe | 74 | 0.3% |
| paul | 71 | 0.3% |
| theo | 65 | 0.3% |
| sarah | 65 | 0.3% |
| Other values (2994) | 23168 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 19379 | |
| e | 14302 | 10.3% |
| i | 12093 | 8.7% |
| n | 11632 | 8.3% |
| l | 9377 | 6.7% |
| r | 7174 | 5.1% |
| o | 6199 | 4.4% |
| s | 4575 | 3.3% |
| h | 4428 | 3.2% |
| y | 4247 | 3.0% |
| Other values (45) | 46099 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 139505 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 19379 | |
| e | 14302 | 10.3% |
| i | 12093 | 8.7% |
| n | 11632 | 8.3% |
| l | 9377 | 6.7% |
| r | 7174 | 5.1% |
| o | 6199 | 4.4% |
| s | 4575 | 3.3% |
| h | 4428 | 3.2% |
| y | 4247 | 3.0% |
| Other values (45) | 46099 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 139505 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 19379 | |
| e | 14302 | 10.3% |
| i | 12093 | 8.7% |
| n | 11632 | 8.3% |
| l | 9377 | 6.7% |
| r | 7174 | 5.1% |
| o | 6199 | 4.4% |
| s | 4575 | 3.3% |
| h | 4428 | 3.2% |
| y | 4247 | 3.0% |
| Other values (45) | 46099 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 139505 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 19379 | |
| e | 14302 | 10.3% |
| i | 12093 | 8.7% |
| n | 11632 | 8.3% |
| l | 9377 | 6.7% |
| r | 7174 | 5.1% |
| o | 6199 | 4.4% |
| s | 4575 | 3.3% |
| h | 4428 | 3.2% |
| y | 4247 | 3.0% |
| Other values (45) | 46099 |
Gender
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 186.9 KiB |
| Male | |
|---|---|
| Female |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.4273404 |
| Min length | 4 |
Characters and Unicode
| Total characters | 105840 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Male |
|---|---|
| 2nd row | Male |
| 3rd row | Male |
| 4th row | Male |
| 5th row | Male |
Common Values
| Value | Count | Frequency (%) |
| Male | 18798 | |
| Female | 5108 | 21.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| male | 18798 | |
| female | 5108 | 21.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 29014 | |
| a | 23906 | |
| l | 23906 | |
| M | 18798 | |
| F | 5108 | 4.8% |
| m | 5108 | 4.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 105840 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 29014 | |
| a | 23906 | |
| l | 23906 | |
| M | 18798 | |
| F | 5108 | 4.8% |
| m | 5108 | 4.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 105840 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 29014 | |
| a | 23906 | |
| l | 23906 | |
| M | 18798 | |
| F | 5108 | 4.8% |
| m | 5108 | 4.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 105840 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 29014 | |
| a | 23906 | |
| l | 23906 | |
| M | 18798 | |
| F | 5108 | 4.8% |
| m | 5108 | 4.8% |
Annual_Income
Real number (ℝ)
| Distinct | 2508 |
|---|---|
| Distinct (%) | 10.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 830840.29 |
| Minimum | 10080 |
|---|---|
| Maximum | 11200000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 186.9 KiB |
Quantile statistics
| Minimum | 10080 |
|---|---|
| 5-th percentile | 13500 |
| Q1 | 386000 |
| median | 735000 |
| Q3 | 1175750 |
| 95-th percentile | 2100000 |
| Maximum | 11200000 |
| Range | 11189920 |
| Interquartile range (IQR) | 789750 |
Descriptive statistics
| Standard deviation | 720006.4 |
|---|---|
| Coefficient of variation (CV) | 0.86660025 |
| Kurtosis | 7.5723739 |
| Mean | 830840.29 |
| Median Absolute Deviation (MAD) | 395000 |
| Skewness | 1.7398384 |
| Sum | 1.9862068 × 1010 |
| Variance | 5.1840921 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 13500 | 5273 | 22.1% |
| 1100000 | 162 | 0.7% |
| 600000 | 160 | 0.7% |
| 800000 | 151 | 0.6% |
| 1300000 | 148 | 0.6% |
| 1200000 | 142 | 0.6% |
| 650000 | 141 | 0.6% |
| 1000000 | 133 | 0.6% |
| 900000 | 132 | 0.6% |
| 700000 | 128 | 0.5% |
| Other values (2498) | 17336 |
| Value | Count | Frequency (%) |
| 10080 | 1 | < 0.1% |
| 13500 | 5273 | |
| 24000 | 1 | < 0.1% |
| 85000 | 1 | < 0.1% |
| 106000 | 1 | < 0.1% |
| 121000 | 1 | < 0.1% |
| 131000 | 1 | < 0.1% |
| 145000 | 2 | < 0.1% |
| 160000 | 3 | < 0.1% |
| 170000 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 11200000 | 1 | |
| 8000000 | 1 | |
| 7650000 | 1 | |
| 6800000 | 1 | |
| 6600000 | 1 | |
| 6500000 | 1 | |
| 6460000 | 1 | |
| 6400000 | 2 | |
| 6240000 | 1 | |
| 6125000 | 1 |
Dealer_Name
Categorical
HIGH CORRELATION 
| Distinct | 28 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 186.9 KiB |
| Progressive Shippers Cooperative Association No | 1318 |
|---|---|
| Rabun Used Car Sales | 1313 |
| Race Car Help | 1253 |
| Saab-Belle Dodge | 1251 |
| Star Enterprises Inc | 1249 |
| Other values (23) |
Length
| Max length | 47 |
|---|---|
| Median length | 30 |
| Mean length | 21.805614 |
| Min length | 9 |
Characters and Unicode
| Total characters | 521285 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Buddy Storbeck's Diesel Service Inc |
|---|---|
| 2nd row | C & M Motors Inc |
| 3rd row | Capitol KIA |
| 4th row | Chrysler of Tri-Cities |
| 5th row | Chrysler Plymouth |
Common Values
| Value | Count | Frequency (%) |
| Progressive Shippers Cooperative Association No | 1318 | 5.5% |
| Rabun Used Car Sales | 1313 | 5.5% |
| Race Car Help | 1253 | 5.2% |
| Saab-Belle Dodge | 1251 | 5.2% |
| Star Enterprises Inc | 1249 | 5.2% |
| Tri-State Mack Inc | 1249 | 5.2% |
| Ryder Truck Rental and Leasing | 1248 | 5.2% |
| U-Haul CO | 1247 | 5.2% |
| Scrivener Performance Engineering | 1246 | 5.2% |
| Suburban Ford | 1243 | 5.2% |
| Other values (18) | 11289 |
Length
| Value | Count | Frequency (%) |
| inc | 4374 | 5.6% |
| car | 3191 | 4.0% |
| sales | 2570 | 3.3% |
| dodge | 1880 | 2.4% |
| chrysler | 1880 | 2.4% |
| ford | 1872 | 2.4% |
| co | 1871 | 2.4% |
| association | 1318 | 1.7% |
| cooperative | 1318 | 1.7% |
| shippers | 1318 | 1.7% |
| Other values (67) | 57214 |
Most occurring characters
| Value | Count | Frequency (%) |
| 54900 | 10.5% | |
| e | 53665 | 10.3% |
| r | 39723 | 7.6% |
| a | 34108 | 6.5% |
| n | 28257 | 5.4% |
| o | 26081 | 5.0% |
| i | 25985 | 5.0% |
| s | 24245 | 4.7% |
| t | 21426 | 4.1% |
| c | 21343 | 4.1% |
| Other values (37) | 191552 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 521285 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 54900 | 10.5% | |
| e | 53665 | 10.3% |
| r | 39723 | 7.6% |
| a | 34108 | 6.5% |
| n | 28257 | 5.4% |
| o | 26081 | 5.0% |
| i | 25985 | 5.0% |
| s | 24245 | 4.7% |
| t | 21426 | 4.1% |
| c | 21343 | 4.1% |
| Other values (37) | 191552 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 521285 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 54900 | 10.5% | |
| e | 53665 | 10.3% |
| r | 39723 | 7.6% |
| a | 34108 | 6.5% |
| n | 28257 | 5.4% |
| o | 26081 | 5.0% |
| i | 25985 | 5.0% |
| s | 24245 | 4.7% |
| t | 21426 | 4.1% |
| c | 21343 | 4.1% |
| Other values (37) | 191552 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 521285 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 54900 | 10.5% | |
| e | 53665 | 10.3% |
| r | 39723 | 7.6% |
| a | 34108 | 6.5% |
| n | 28257 | 5.4% |
| o | 26081 | 5.0% |
| i | 25985 | 5.0% |
| s | 24245 | 4.7% |
| t | 21426 | 4.1% |
| c | 21343 | 4.1% |
| Other values (37) | 191552 |
Company
Categorical
| Distinct | 30 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 186.9 KiB |
| Chevrolet | |
|---|---|
| Dodge | |
| Ford | 1614 |
| Volkswagen | 1333 |
| Mercedes-B | 1285 |
| Other values (25) |
Length
| Max length | 10 |
|---|---|
| Median length | 8 |
| Mean length | 6.8641345 |
| Min length | 3 |
Characters and Unicode
| Total characters | 164094 |
|---|---|
| Distinct characters | 41 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Ford |
|---|---|
| 2nd row | Dodge |
| 3rd row | Cadillac |
| 4th row | Toyota |
| 5th row | Acura |
Common Values
| Value | Count | Frequency (%) |
| Chevrolet | 1819 | 7.6% |
| Dodge | 1671 | 7.0% |
| Ford | 1614 | 6.8% |
| Volkswagen | 1333 | 5.6% |
| Mercedes-B | 1285 | 5.4% |
| Mitsubishi | 1277 | 5.3% |
| Chrysler | 1120 | 4.7% |
| Oldsmobile | 1111 | 4.6% |
| Toyota | 1110 | 4.6% |
| Nissan | 886 | 3.7% |
| Other values (20) | 10680 |
Length
| Value | Count | Frequency (%) |
| chevrolet | 1819 | 7.6% |
| dodge | 1671 | 7.0% |
| ford | 1614 | 6.8% |
| volkswagen | 1333 | 5.6% |
| mercedes-b | 1285 | 5.4% |
| mitsubishi | 1277 | 5.3% |
| chrysler | 1120 | 4.7% |
| oldsmobile | 1111 | 4.6% |
| toyota | 1110 | 4.6% |
| nissan | 886 | 3.7% |
| Other values (20) | 10680 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 15491 | 9.4% |
| o | 14320 | 8.7% |
| r | 10927 | 6.7% |
| s | 10338 | 6.3% |
| l | 9696 | 5.9% |
| i | 9524 | 5.8% |
| a | 8861 | 5.4% |
| d | 7773 | 4.7% |
| u | 7006 | 4.3% |
| t | 6400 | 3.9% |
| Other values (31) | 63758 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 164094 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 15491 | 9.4% |
| o | 14320 | 8.7% |
| r | 10927 | 6.7% |
| s | 10338 | 6.3% |
| l | 9696 | 5.9% |
| i | 9524 | 5.8% |
| a | 8861 | 5.4% |
| d | 7773 | 4.7% |
| u | 7006 | 4.3% |
| t | 6400 | 3.9% |
| Other values (31) | 63758 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 164094 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 15491 | 9.4% |
| o | 14320 | 8.7% |
| r | 10927 | 6.7% |
| s | 10338 | 6.3% |
| l | 9696 | 5.9% |
| i | 9524 | 5.8% |
| a | 8861 | 5.4% |
| d | 7773 | 4.7% |
| u | 7006 | 4.3% |
| t | 6400 | 3.9% |
| Other values (31) | 63758 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 164094 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 15491 | 9.4% |
| o | 14320 | 8.7% |
| r | 10927 | 6.7% |
| s | 10338 | 6.3% |
| l | 9696 | 5.9% |
| i | 9524 | 5.8% |
| a | 8861 | 5.4% |
| d | 7773 | 4.7% |
| u | 7006 | 4.3% |
| t | 6400 | 3.9% |
| Other values (31) | 63758 |
Model
Text
| Distinct | 154 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 186.9 KiB |
Length
| Max length | 14 |
|---|---|
| Median length | 11 |
| Mean length | 6.5813185 |
| Min length | 2 |
Characters and Unicode
| Total characters | 157333 |
|---|---|
| Distinct characters | 60 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Expedition |
|---|---|
| 2nd row | Durango |
| 3rd row | Eldorado |
| 4th row | Celica |
| 5th row | TL |
| Value | Count | Frequency (%) |
| grand | 700 | 2.6% |
| ram | 658 | 2.4% |
| coupe | 435 | 1.6% |
| diamante | 418 | 1.6% |
| silhouette | 411 | 1.5% |
| prizm | 411 | 1.5% |
| passat | 391 | 1.5% |
| pickup | 383 | 1.4% |
| jetta | 382 | 1.4% |
| rl | 372 | 1.4% |
| Other values (151) | 22385 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 14726 | 9.4% |
| r | 13076 | 8.3% |
| e | 12819 | 8.1% |
| o | 9082 | 5.8% |
| t | 8224 | 5.2% |
| i | 8111 | 5.2% |
| n | 7890 | 5.0% |
| C | 5519 | 3.5% |
| l | 5480 | 3.5% |
| S | 5115 | 3.3% |
| Other values (50) | 67291 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 157333 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 14726 | 9.4% |
| r | 13076 | 8.3% |
| e | 12819 | 8.1% |
| o | 9082 | 5.8% |
| t | 8224 | 5.2% |
| i | 8111 | 5.2% |
| n | 7890 | 5.0% |
| C | 5519 | 3.5% |
| l | 5480 | 3.5% |
| S | 5115 | 3.3% |
| Other values (50) | 67291 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 157333 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 14726 | 9.4% |
| r | 13076 | 8.3% |
| e | 12819 | 8.1% |
| o | 9082 | 5.8% |
| t | 8224 | 5.2% |
| i | 8111 | 5.2% |
| n | 7890 | 5.0% |
| C | 5519 | 3.5% |
| l | 5480 | 3.5% |
| S | 5115 | 3.3% |
| Other values (50) | 67291 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 157333 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 14726 | 9.4% |
| r | 13076 | 8.3% |
| e | 12819 | 8.1% |
| o | 9082 | 5.8% |
| t | 8224 | 5.2% |
| i | 8111 | 5.2% |
| n | 7890 | 5.0% |
| C | 5519 | 3.5% |
| l | 5480 | 3.5% |
| S | 5115 | 3.3% |
| Other values (50) | 67291 |
Engine
Categorical
HIGH CORRELATION 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 186.9 KiB |
| Double Overhead Camshaft | |
|---|---|
| Overhead Camshaft |
Length
| Max length | 27 |
|---|---|
| Median length | 27 |
| Mean length | 22.258513 |
| Min length | 17 |
Characters and Unicode
| Total characters | 532112 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Double Overhead Camshaft |
|---|---|
| 2nd row | Double Overhead Camshaft |
| 3rd row | Overhead Camshaft |
| 4th row | Overhead Camshaft |
| 5th row | Double Overhead Camshaft |
Common Values
| Value | Count | Frequency (%) |
| Double Overhead Camshaft | 12571 | |
| Overhead Camshaft | 11335 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| overhead | 23906 | |
| camshaft | 23906 | |
| doubleã‚â | 12571 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 71718 | 13.5% |
| e | 60383 | 11.3% |
| h | 47812 | 9.0% |
| v | 23906 | 4.5% |
| r | 23906 | 4.5% |
| f | 23906 | 4.5% |
| s | 23906 | 4.5% |
| m | 23906 | 4.5% |
| C | 23906 | 4.5% |
| 23906 | 4.5% | |
| Other values (12) | 184857 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 532112 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 71718 | 13.5% |
| e | 60383 | 11.3% |
| h | 47812 | 9.0% |
| v | 23906 | 4.5% |
| r | 23906 | 4.5% |
| f | 23906 | 4.5% |
| s | 23906 | 4.5% |
| m | 23906 | 4.5% |
| C | 23906 | 4.5% |
| 23906 | 4.5% | |
| Other values (12) | 184857 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 532112 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 71718 | 13.5% |
| e | 60383 | 11.3% |
| h | 47812 | 9.0% |
| v | 23906 | 4.5% |
| r | 23906 | 4.5% |
| f | 23906 | 4.5% |
| s | 23906 | 4.5% |
| m | 23906 | 4.5% |
| C | 23906 | 4.5% |
| 23906 | 4.5% | |
| Other values (12) | 184857 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 532112 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 71718 | 13.5% |
| e | 60383 | 11.3% |
| h | 47812 | 9.0% |
| v | 23906 | 4.5% |
| r | 23906 | 4.5% |
| f | 23906 | 4.5% |
| s | 23906 | 4.5% |
| m | 23906 | 4.5% |
| C | 23906 | 4.5% |
| 23906 | 4.5% | |
| Other values (12) | 184857 |
Transmission
Categorical
HIGH CORRELATION 
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 186.9 KiB |
| Auto | |
|---|---|
| Manual |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.9482975 |
| Min length | 4 |
Characters and Unicode
| Total characters | 118294 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Auto |
|---|---|
| 2nd row | Auto |
| 3rd row | Manual |
| 4th row | Manual |
| 5th row | Auto |
Common Values
| Value | Count | Frequency (%) |
| Auto | 12571 | |
| Manual | 11335 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| auto | 12571 | |
| manual | 11335 |
Most occurring characters
| Value | Count | Frequency (%) |
| u | 23906 | |
| a | 22670 | |
| A | 12571 | |
| t | 12571 | |
| o | 12571 | |
| M | 11335 | |
| n | 11335 | |
| l | 11335 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 118294 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| u | 23906 | |
| a | 22670 | |
| A | 12571 | |
| t | 12571 | |
| o | 12571 | |
| M | 11335 | |
| n | 11335 | |
| l | 11335 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 118294 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| u | 23906 | |
| a | 22670 | |
| A | 12571 | |
| t | 12571 | |
| o | 12571 | |
| M | 11335 | |
| n | 11335 | |
| l | 11335 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 118294 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| u | 23906 | |
| a | 22670 | |
| A | 12571 | |
| t | 12571 | |
| o | 12571 | |
| M | 11335 | |
| n | 11335 | |
| l | 11335 |
Color
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 186.9 KiB |
| Pale White | |
|---|---|
| Black | |
| Red |
Length
| Max length | 10 |
|---|---|
| Median length | 5 |
| Mean length | 6.9532335 |
| Min length | 3 |
Characters and Unicode
| Total characters | 166224 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Black |
|---|---|
| 2nd row | Black |
| 3rd row | Red |
| 4th row | Pale White |
| 5th row | Red |
Common Values
| Value | Count | Frequency (%) |
| Pale White | 11256 | |
| Black | 7857 | |
| Red | 4793 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| pale | 11256 | |
| white | 11256 | |
| black | 7857 | |
| red | 4793 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 27305 | |
| a | 19113 | |
| l | 19113 | |
| P | 11256 | |
| 11256 | ||
| W | 11256 | |
| h | 11256 | |
| i | 11256 | |
| t | 11256 | |
| B | 7857 | 4.7% |
| Other values (4) | 25300 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 166224 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 27305 | |
| a | 19113 | |
| l | 19113 | |
| P | 11256 | |
| 11256 | ||
| W | 11256 | |
| h | 11256 | |
| i | 11256 | |
| t | 11256 | |
| B | 7857 | 4.7% |
| Other values (4) | 25300 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 166224 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 27305 | |
| a | 19113 | |
| l | 19113 | |
| P | 11256 | |
| 11256 | ||
| W | 11256 | |
| h | 11256 | |
| i | 11256 | |
| t | 11256 | |
| B | 7857 | 4.7% |
| Other values (4) | 25300 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 166224 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 27305 | |
| a | 19113 | |
| l | 19113 | |
| P | 11256 | |
| 11256 | ||
| W | 11256 | |
| h | 11256 | |
| i | 11256 | |
| t | 11256 | |
| B | 7857 | 4.7% |
| Other values (4) | 25300 |
Price_($)
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 870 |
|---|---|
| Distinct (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28090.248 |
| Minimum | 1200 |
|---|---|
| Maximum | 85800 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 186.9 KiB |
Quantile statistics
| Minimum | 1200 |
|---|---|
| 5-th percentile | 12000 |
| Q1 | 18001 |
| median | 23000 |
| Q3 | 34000 |
| 95-th percentile | 61000 |
| Maximum | 85800 |
| Range | 84600 |
| Interquartile range (IQR) | 15999 |
Descriptive statistics
| Standard deviation | 14788.688 |
|---|---|
| Coefficient of variation (CV) | 0.52647053 |
| Kurtosis | 2.0083154 |
| Mean | 28090.248 |
| Median Absolute Deviation (MAD) | 6300 |
| Skewness | 1.4663159 |
| Sum | 6.7152546 × 108 |
| Variance | 2.1870528 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 22000 | 1191 | 5.0% |
| 19000 | 974 | 4.1% |
| 21000 | 873 | 3.7% |
| 26000 | 689 | 2.9% |
| 18000 | 627 | 2.6% |
| 17000 | 621 | 2.6% |
| 16000 | 620 | 2.6% |
| 12000 | 619 | 2.6% |
| 31000 | 604 | 2.5% |
| 20000 | 533 | 2.2% |
| Other values (860) | 16555 |
| Value | Count | Frequency (%) |
| 1200 | 1 | < 0.1% |
| 1450 | 1 | < 0.1% |
| 1700 | 1 | < 0.1% |
| 2200 | 1 | < 0.1% |
| 4200 | 1 | < 0.1% |
| 4300 | 1 | < 0.1% |
| 9000 | 169 | |
| 9001 | 59 | 0.2% |
| 9100 | 3 | < 0.1% |
| 9200 | 3 | < 0.1% |
| Value | Count | Frequency (%) |
| 85800 | 1 | < 0.1% |
| 85601 | 1 | < 0.1% |
| 85600 | 2 | < 0.1% |
| 85500 | 2 | < 0.1% |
| 85400 | 1 | < 0.1% |
| 85301 | 1 | < 0.1% |
| 85300 | 1 | < 0.1% |
| 85250 | 1 | < 0.1% |
| 85200 | 1 | < 0.1% |
| 85001 | 22 |
Dealer_No
Categorical
HIGH CORRELATION 
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 186.9 KiB |
| 85257-3102 | |
|---|---|
| 53546-9427 | |
| 78758-7841 | |
| 06457-3834 | |
| 38701-8047 | |
| Other values (2) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 239060 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 06457-3834 |
|---|---|
| 2nd row | 60504-7114 |
| 3rd row | 38701-8047 |
| 4th row | 99301-3882 |
| 5th row | 53546-9427 |
Common Values
| Value | Count | Frequency (%) |
| 85257-3102 | 3814 | |
| 53546-9427 | 3813 | |
| 78758-7841 | 3753 | |
| 06457-3834 | 3132 | |
| 38701-8047 | 3132 | |
| 99301-3882 | 3132 | |
| 60504-7114 | 3130 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 85257-3102 | 3814 | |
| 53546-9427 | 3813 | |
| 78758-7841 | 3753 | |
| 06457-3834 | 3132 | |
| 38701-8047 | 3132 | |
| 99301-3882 | 3132 | |
| 60504-7114 | 3130 |
Most occurring characters
| Value | Count | Frequency (%) |
| 7 | 31412 | |
| 8 | 30733 | |
| 4 | 27035 | |
| 5 | 25269 | |
| - | 23906 | |
| 3 | 23287 | |
| 0 | 22602 | |
| 1 | 20091 | |
| 2 | 14573 | |
| 9 | 10077 | 4.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 239060 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 7 | 31412 | |
| 8 | 30733 | |
| 4 | 27035 | |
| 5 | 25269 | |
| - | 23906 | |
| 3 | 23287 | |
| 0 | 22602 | |
| 1 | 20091 | |
| 2 | 14573 | |
| 9 | 10077 | 4.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 239060 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 7 | 31412 | |
| 8 | 30733 | |
| 4 | 27035 | |
| 5 | 25269 | |
| - | 23906 | |
| 3 | 23287 | |
| 0 | 22602 | |
| 1 | 20091 | |
| 2 | 14573 | |
| 9 | 10077 | 4.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 239060 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 7 | 31412 | |
| 8 | 30733 | |
| 4 | 27035 | |
| 5 | 25269 | |
| - | 23906 | |
| 3 | 23287 | |
| 0 | 22602 | |
| 1 | 20091 | |
| 2 | 14573 | |
| 9 | 10077 | 4.2% |
Body_Style
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 186.9 KiB |
| SUV | |
|---|---|
| Hatchback | |
| Sedan | |
| Passenger | |
| Hardtop |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 6.4007362 |
| Min length | 3 |
Characters and Unicode
| Total characters | 153016 |
|---|---|
| Distinct characters | 19 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SUV |
|---|---|
| 2nd row | SUV |
| 3rd row | Passenger |
| 4th row | SUV |
| 5th row | Hatchback |
Common Values
| Value | Count | Frequency (%) |
| SUV | 6374 | |
| Hatchback | 6128 | |
| Sedan | 4488 | |
| Passenger | 3945 | |
| Hardtop | 2971 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| suv | 6374 | |
| hatchback | 6128 | |
| sedan | 4488 | |
| passenger | 3945 | |
| hardtop | 2971 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 23660 | |
| e | 12378 | 8.1% |
| c | 12256 | 8.0% |
| S | 10862 | 7.1% |
| H | 9099 | 5.9% |
| t | 9099 | 5.9% |
| n | 8433 | 5.5% |
| s | 7890 | 5.2% |
| d | 7459 | 4.9% |
| r | 6916 | 4.5% |
| Other values (9) | 44964 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 153016 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 23660 | |
| e | 12378 | 8.1% |
| c | 12256 | 8.0% |
| S | 10862 | 7.1% |
| H | 9099 | 5.9% |
| t | 9099 | 5.9% |
| n | 8433 | 5.5% |
| s | 7890 | 5.2% |
| d | 7459 | 4.9% |
| r | 6916 | 4.5% |
| Other values (9) | 44964 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 153016 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 23660 | |
| e | 12378 | 8.1% |
| c | 12256 | 8.0% |
| S | 10862 | 7.1% |
| H | 9099 | 5.9% |
| t | 9099 | 5.9% |
| n | 8433 | 5.5% |
| s | 7890 | 5.2% |
| d | 7459 | 4.9% |
| r | 6916 | 4.5% |
| Other values (9) | 44964 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 153016 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 23660 | |
| e | 12378 | 8.1% |
| c | 12256 | 8.0% |
| S | 10862 | 7.1% |
| H | 9099 | 5.9% |
| t | 9099 | 5.9% |
| n | 8433 | 5.5% |
| s | 7890 | 5.2% |
| d | 7459 | 4.9% |
| r | 6916 | 4.5% |
| Other values (9) | 44964 |
Phone
Real number (ℝ)
| Distinct | 23804 |
|---|---|
| Distinct (%) | 99.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7497740.6 |
| Minimum | 6000101 |
|---|---|
| Maximum | 8999579 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 186.9 KiB |
Quantile statistics
| Minimum | 6000101 |
|---|---|
| 5-th percentile | 6146284 |
| Q1 | 6746495 |
| median | 7496197.5 |
| Q3 | 8248146.2 |
| 95-th percentile | 8849134.5 |
| Maximum | 8999579 |
| Range | 2999478 |
| Interquartile range (IQR) | 1501651.2 |
Descriptive statistics
| Standard deviation | 867492 |
|---|---|
| Coefficient of variation (CV) | 0.11570045 |
| Kurtosis | -1.1979186 |
| Mean | 7497740.6 |
| Median Absolute Deviation (MAD) | 750964 |
| Skewness | 0.00086348034 |
| Sum | 1.7924099 × 1011 |
| Variance | 7.5254236 × 1011 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6005535 | 2 | < 0.1% |
| 7298842 | 2 | < 0.1% |
| 6955907 | 2 | < 0.1% |
| 6854031 | 2 | < 0.1% |
| 8895808 | 2 | < 0.1% |
| 8389695 | 2 | < 0.1% |
| 7390875 | 2 | < 0.1% |
| 8168355 | 2 | < 0.1% |
| 8602618 | 2 | < 0.1% |
| 6257129 | 2 | < 0.1% |
| Other values (23794) | 23886 |
| Value | Count | Frequency (%) |
| 6000101 | 1 | |
| 6000191 | 1 | |
| 6000247 | 1 | |
| 6000326 | 1 | |
| 6000356 | 1 | |
| 6000458 | 1 | |
| 6000493 | 1 | |
| 6000559 | 1 | |
| 6000740 | 1 | |
| 6000749 | 1 |
| Value | Count | Frequency (%) |
| 8999579 | 1 | |
| 8999305 | 1 | |
| 8998913 | 1 | |
| 8998867 | 1 | |
| 8998864 | 1 | |
| 8998836 | 1 | |
| 8998761 | 1 | |
| 8998696 | 1 | |
| 8998568 | 1 | |
| 8998480 | 1 |
Amount_paid_for_insurance
Real number (ℝ)
HIGH CORRELATION 
| Distinct | 3421 |
|---|---|
| Distinct (%) | 14.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1654.5178 |
| Minimum | 103 |
|---|---|
| Maximum | 4762 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 186.9 KiB |
Quantile statistics
| Minimum | 103 |
|---|---|
| 5-th percentile | 808 |
| Q1 | 1138 |
| median | 1432 |
| Q3 | 1990 |
| 95-th percentile | 3291 |
| Maximum | 4762 |
| Range | 4659 |
| Interquartile range (IQR) | 852 |
Descriptive statistics
| Standard deviation | 753.48166 |
|---|---|
| Coefficient of variation (CV) | 0.45540862 |
| Kurtosis | 1.8423571 |
| Mean | 1654.5178 |
| Median Absolute Deviation (MAD) | 357 |
| Skewness | 1.3806533 |
| Sum | 39552902 |
| Variance | 567734.62 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1369 | 32 | 0.1% |
| 1163 | 32 | 0.1% |
| 1307 | 31 | 0.1% |
| 1311 | 31 | 0.1% |
| 1275 | 30 | 0.1% |
| 1325 | 30 | 0.1% |
| 1408 | 30 | 0.1% |
| 1305 | 30 | 0.1% |
| 1069 | 29 | 0.1% |
| 1321 | 29 | 0.1% |
| Other values (3411) | 23602 |
| Value | Count | Frequency (%) |
| 103 | 1 | |
| 187 | 1 | |
| 450 | 1 | |
| 453 | 1 | |
| 460 | 1 | |
| 463 | 1 | |
| 464 | 2 | |
| 465 | 1 | |
| 470 | 1 | |
| 471 | 2 |
| Value | Count | Frequency (%) |
| 4762 | 1 | |
| 4753 | 1 | |
| 4749 | 1 | |
| 4748 | 1 | |
| 4738 | 1 | |
| 4737 | 1 | |
| 4733 | 1 | |
| 4726 | 1 | |
| 4724 | 1 | |
| 4698 | 1 |
Claim_amount
Real number (ℝ)
ZEROS 
| Distinct | 230 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 282.46327 |
| Minimum | 0 |
|---|---|
| Maximum | 8560 |
| Zeros | 21516 |
| Zeros (%) | 90.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 186.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 2200 |
| Maximum | 8560 |
| Range | 8560 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 977.50653 |
|---|---|
| Coefficient of variation (CV) | 3.46065 |
| Kurtosis | 20.505985 |
| Mean | 282.46327 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.2414879 |
| Sum | 6752567 |
| Variance | 955519.01 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 21516 | |
| 2200 | 150 | 0.6% |
| 1900 | 138 | 0.6% |
| 2100 | 112 | 0.5% |
| 1600 | 95 | 0.4% |
| 1700 | 94 | 0.4% |
| 1200 | 92 | 0.4% |
| 2600 | 80 | 0.3% |
| 3100 | 77 | 0.3% |
| 1800 | 77 | 0.3% |
| Other values (220) | 1475 | 6.2% |
| Value | Count | Frequency (%) |
| 0 | 21516 | |
| 145 | 1 | < 0.1% |
| 900 | 19 | 0.1% |
| 925 | 1 | < 0.1% |
| 950 | 3 | < 0.1% |
| 960 | 1 | < 0.1% |
| 980 | 1 | < 0.1% |
| 1000 | 17 | 0.1% |
| 1040 | 1 | < 0.1% |
| 1050 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 8560 | 3 | < 0.1% |
| 8540 | 1 | < 0.1% |
| 8530 | 1 | < 0.1% |
| 8500 | 6 | < 0.1% |
| 8250 | 1 | < 0.1% |
| 8200 | 11 | |
| 7560 | 1 | < 0.1% |
| 7550 | 1 | < 0.1% |
| 7510 | 1 | < 0.1% |
| 7500 | 15 |
City
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 186.9 KiB |
| Liepaja | |
|---|---|
| Tukums | |
| Riga | |
| Daugavpils | |
| Jelgava |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 7.1587468 |
| Min length | 4 |
Characters and Unicode
| Total characters | 171137 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Riga |
|---|---|
| 2nd row | Liepaja |
| 3rd row | Riga |
| 4th row | Jelgava |
| 5th row | Liepaja |
Common Values
| Value | Count | Frequency (%) |
| Liepaja | 4057 | |
| Tukums | 4008 | |
| Riga | 3987 | |
| Daugavpils | 3976 | |
| Jelgava | 3960 | |
| Ventspils | 3918 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| liepaja | 4057 | |
| tukums | 4008 | |
| riga | 3987 | |
| daugavpils | 3976 | |
| jelgava | 3960 | |
| ventspils | 3918 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 27973 | |
| i | 15938 | |
| s | 15820 | 9.2% |
| u | 11992 | 7.0% |
| p | 11951 | 7.0% |
| e | 11935 | 7.0% |
| g | 11923 | 7.0% |
| l | 11854 | 6.9% |
| v | 7936 | 4.6% |
| L | 4057 | 2.4% |
| Other values (10) | 39758 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 171137 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 27973 | |
| i | 15938 | |
| s | 15820 | 9.2% |
| u | 11992 | 7.0% |
| p | 11951 | 7.0% |
| e | 11935 | 7.0% |
| g | 11923 | 7.0% |
| l | 11854 | 6.9% |
| v | 7936 | 4.6% |
| L | 4057 | 2.4% |
| Other values (10) | 39758 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 171137 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 27973 | |
| i | 15938 | |
| s | 15820 | 9.2% |
| u | 11992 | 7.0% |
| p | 11951 | 7.0% |
| e | 11935 | 7.0% |
| g | 11923 | 7.0% |
| l | 11854 | 6.9% |
| v | 7936 | 4.6% |
| L | 4057 | 2.4% |
| Other values (10) | 39758 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 171137 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 27973 | |
| i | 15938 | |
| s | 15820 | 9.2% |
| u | 11992 | 7.0% |
| p | 11951 | 7.0% |
| e | 11935 | 7.0% |
| g | 11923 | 7.0% |
| l | 11854 | 6.9% |
| v | 7936 | 4.6% |
| L | 4057 | 2.4% |
| Other values (10) | 39758 |
Year
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 186.9 KiB |
| 2023 | |
|---|---|
| 2022 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 95624 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2022 |
|---|---|
| 2nd row | 2022 |
| 3rd row | 2022 |
| 4th row | 2022 |
| 5th row | 2022 |
Common Values
| Value | Count | Frequency (%) |
| 2023 | 13261 | |
| 2022 | 10645 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2023 | 13261 | |
| 2022 | 10645 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 58457 | |
| 0 | 23906 | |
| 3 | 13261 | 13.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 95624 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 58457 | |
| 0 | 23906 | |
| 3 | 13261 | 13.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 95624 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 58457 | |
| 0 | 23906 | |
| 3 | 13261 | 13.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 95624 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 58457 | |
| 0 | 23906 | |
| 3 | 13261 | 13.9% |
Month
Real number (ℝ)
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.852924 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 93.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 5 |
| median | 9 |
| Q3 | 11 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 3.2579854 |
|---|---|
| Coefficient of variation (CV) | 0.41487546 |
| Kurtosis | -0.99435964 |
| Mean | 7.852924 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.41558155 |
| Sum | 187732 |
| Variance | 10.614469 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 12 | 3546 | |
| 11 | 3470 | |
| 9 | 3305 | |
| 5 | 1895 | |
| 10 | 1830 | |
| 7 | 1725 | |
| 6 | 1715 | |
| 8 | 1705 | |
| 4 | 1655 | |
| 3 | 1535 | |
| Other values (2) | 1525 |
| Value | Count | Frequency (%) |
| 1 | 790 | 3.3% |
| 2 | 735 | 3.1% |
| 3 | 1535 | |
| 4 | 1655 | |
| 5 | 1895 | |
| 6 | 1715 | |
| 7 | 1725 | |
| 8 | 1705 | |
| 9 | 3305 | |
| 10 | 1830 |
| Value | Count | Frequency (%) |
| 12 | 3546 | |
| 11 | 3470 | |
| 10 | 1830 | |
| 9 | 3305 | |
| 8 | 1705 | |
| 7 | 1725 | |
| 6 | 1715 | |
| 5 | 1895 | |
| 4 | 1655 | |
| 3 | 1535 |
Day
Real number (ℝ)
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.473061 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 93.5 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 15 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.7341721 |
|---|---|
| Coefficient of variation (CV) | 0.56447603 |
| Kurtosis | -1.1906513 |
| Mean | 15.473061 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0.036949301 |
| Sum | 369899 |
| Variance | 76.285762 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5 | 1005 | 4.2% |
| 8 | 975 | 4.1% |
| 12 | 940 | 3.9% |
| 26 | 930 | 3.9% |
| 21 | 905 | 3.8% |
| 25 | 880 | 3.7% |
| 13 | 880 | 3.7% |
| 17 | 840 | 3.5% |
| 3 | 835 | 3.5% |
| 10 | 805 | 3.4% |
| Other values (21) | 14911 |
| Value | Count | Frequency (%) |
| 1 | 795 | |
| 2 | 755 | |
| 3 | 835 | |
| 4 | 765 | |
| 5 | 1005 | |
| 6 | 705 | |
| 7 | 675 | |
| 8 | 975 | |
| 9 | 725 | |
| 10 | 805 |
| Value | Count | Frequency (%) |
| 31 | 495 | |
| 30 | 615 | |
| 29 | 551 | |
| 28 | 705 | |
| 27 | 670 | |
| 26 | 930 | |
| 25 | 880 | |
| 24 | 760 | |
| 23 | 800 | |
| 22 | 725 |
| Amount_paid_for_insurance | Annual_Income | Body_Style | City | Claim_amount | Color | Company | Day | Dealer_Name | Dealer_No | Engine | Gender | Month | Phone | Price_($) | Transmission | Year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Amount_paid_for_insurance | 1.000 | 0.012 | 0.084 | 0.000 | 0.014 | 0.093 | 0.158 | -0.002 | 0.000 | 0.000 | 0.135 | 0.000 | 0.005 | 0.000 | 0.952 | 0.135 | 0.000 |
| Annual_Income | 0.012 | 1.000 | 0.006 | 0.011 | -0.001 | 0.000 | 0.011 | 0.008 | 0.000 | 0.000 | 0.000 | 0.063 | -0.008 | -0.002 | 0.017 | 0.000 | 0.041 |
| Body_Style | 0.084 | 0.006 | 1.000 | 0.000 | -0.001 | 0.036 | 0.316 | 0.002 | 0.000 | 0.000 | 0.083 | 0.000 | -0.016 | -0.010 | 0.014 | 0.083 | 0.065 |
| City | 0.000 | 0.011 | 0.000 | 1.000 | 0.003 | 0.000 | 0.000 | -0.000 | 0.011 | 0.009 | 0.000 | 0.000 | 0.021 | -0.010 | 0.004 | 0.000 | 0.018 |
| Claim_amount | 0.014 | -0.001 | -0.001 | 0.003 | 1.000 | 0.028 | 0.068 | 0.004 | 0.004 | 0.000 | 0.070 | 0.000 | 0.001 | -0.004 | 0.014 | 0.070 | 0.000 |
| Color | 0.093 | 0.000 | 0.036 | 0.000 | 0.028 | 1.000 | 0.183 | 0.007 | 0.000 | 0.000 | 0.000 | 0.000 | -0.030 | 0.002 | -0.006 | 0.000 | 0.030 |
| Company | 0.158 | 0.011 | 0.316 | 0.000 | 0.068 | 0.183 | 1.000 | 0.010 | 0.000 | 0.000 | 0.250 | 0.018 | -0.002 | 0.002 | 0.024 | 0.250 | 0.000 |
| Day | -0.002 | 0.008 | 0.002 | -0.000 | 0.004 | 0.007 | 0.010 | 1.000 | 0.000 | 0.000 | 0.014 | 0.000 | -0.015 | -0.005 | -0.002 | 0.014 | 0.043 |
| Dealer_Name | 0.000 | 0.000 | 0.000 | 0.011 | 0.004 | 0.000 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.010 | -0.000 | -0.004 | 0.007 | 0.000 | 0.000 |
| Dealer_No | 0.000 | 0.000 | 0.000 | 0.009 | 0.000 | 0.000 | 0.000 | 0.000 | 1.000 | 1.000 | 0.000 | 0.000 | 0.001 | -0.011 | 0.004 | 0.000 | 0.000 |
| Engine | 0.135 | 0.000 | 0.083 | 0.000 | 0.070 | 0.000 | 0.250 | 0.014 | 0.000 | 0.000 | 1.000 | 0.000 | -0.008 | -0.005 | -0.058 | 1.000 | 0.007 |
| Gender | 0.000 | 0.063 | 0.000 | 0.000 | 0.000 | 0.000 | 0.018 | 0.000 | 0.010 | 0.000 | 0.000 | 1.000 | 0.035 | -0.002 | -0.003 | 0.000 | 0.028 |
| Month | 0.005 | -0.008 | -0.016 | 0.021 | 0.001 | -0.030 | -0.002 | -0.015 | -0.000 | 0.001 | -0.008 | 0.035 | 1.000 | 0.005 | 0.006 | 0.006 | 0.052 |
| Phone | 0.000 | -0.002 | -0.010 | -0.010 | -0.004 | 0.002 | 0.002 | -0.005 | -0.004 | -0.011 | -0.005 | -0.002 | 0.005 | 1.000 | -0.000 | 0.000 | 0.000 |
| Price_($) | 0.952 | 0.017 | 0.014 | 0.004 | 0.014 | -0.006 | 0.024 | -0.002 | 0.007 | 0.004 | -0.058 | -0.003 | 0.006 | -0.000 | 1.000 | 0.209 | 0.000 |
| Transmission | 0.135 | 0.000 | 0.083 | 0.000 | 0.070 | 0.000 | 0.250 | 0.014 | 0.000 | 0.000 | 1.000 | 0.000 | 0.006 | 0.000 | 0.209 | 1.000 | 0.007 |
| Year | 0.000 | 0.041 | 0.065 | 0.018 | 0.000 | 0.030 | 0.000 | 0.043 | 0.000 | 0.000 | 0.007 | 0.028 | 0.052 | 0.000 | 0.000 | 0.007 | 1.000 |
| Car_id | Date | Customer_Name | Gender | Annual_Income | Dealer_Name | Company | Model | Engine | Transmission | Color | Price_($) | Dealer_No | Body_Style | Phone | Amount_paid_for_insurance | Claim_amount | City | Year | Month | Day | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | C_CND_000001 | 2022-01-02 | Geraldine | Male | 13500 | Buddy Storbeck's Diesel Service Inc | Ford | Expedition | Double Overhead Camshaft | Auto | Black | 26000 | 06457-3834 | SUV | 8264678 | 1665 | 0.00 | Riga | 2022 | 1 | 2 |
| 1 | C_CND_000002 | 2022-01-02 | Gia | Male | 1480000 | C & M Motors Inc | Dodge | Durango | Double Overhead Camshaft | Auto | Black | 19000 | 60504-7114 | SUV | 6848189 | 1332 | 1900.00 | Liepaja | 2022 | 1 | 2 |
| 2 | C_CND_000003 | 2022-01-02 | Gianna | Male | 1035000 | Capitol KIA | Cadillac | Eldorado | Overhead Camshaft | Manual | Red | 31500 | 38701-8047 | Passenger | 7298798 | 1897 | 0.00 | Riga | 2022 | 1 | 2 |
| 3 | C_CND_000004 | 2022-01-02 | Giselle | Male | 13500 | Chrysler of Tri-Cities | Toyota | Celica | Overhead Camshaft | Manual | Pale White | 14000 | 99301-3882 | SUV | 6257557 | 1176 | 0.00 | Jelgava | 2022 | 1 | 2 |
| 4 | C_CND_000005 | 2022-01-02 | Grace | Male | 1465000 | Chrysler Plymouth | Acura | TL | Double Overhead Camshaft | Auto | Red | 24500 | 53546-9427 | Hatchback | 7081483 | 1323 | 2450.00 | Liepaja | 2022 | 1 | 2 |
| 5 | C_CND_000006 | 2022-01-02 | Guadalupe | Male | 850000 | Classic Chevy | Mitsubishi | Diamante | Overhead Camshaft | Manual | Pale White | 12000 | 85257-3102 | Hatchback | 7315216 | 830 | 0.00 | Riga | 2022 | 1 | 2 |
| 6 | C_CND_000007 | 2022-01-02 | Hailey | Male | 1600000 | Clay Johnson Auto Sales | Toyota | Corolla | Overhead Camshaft | Manual | Pale White | 14000 | 78758-7841 | Passenger | 7727879 | 717 | 0.00 | Riga | 2022 | 1 | 2 |
| 7 | C_CND_000008 | 2022-01-02 | Graham | Male | 13500 | U-Haul CO | Mitsubishi | Galant | Double Overhead Camshaft | Auto | Pale White | 42000 | 78758-7841 | Passenger | 6206512 | 2183 | 0.00 | Jelgava | 2022 | 1 | 2 |
| 8 | C_CND_000009 | 2022-01-02 | Naomi | Male | 815000 | Rabun Used Car Sales | Chevrolet | Malibu | Overhead Camshaft | Manual | Pale White | 82000 | 85257-3102 | Hardtop | 7194857 | 4206 | 0.00 | Ventspils | 2022 | 1 | 2 |
| 9 | C_CND_000010 | 2022-01-02 | Grayson | Female | 13500 | Rabun Used Car Sales | Ford | Escort | Double Overhead Camshaft | Auto | Pale White | 15000 | 85257-3102 | Passenger | 7836892 | 873 | 0.00 | Ventspils | 2022 | 1 | 2 |
| Car_id | Date | Customer_Name | Gender | Annual_Income | Dealer_Name | Company | Model | Engine | Transmission | Color | Price_($) | Dealer_No | Body_Style | Phone | Amount_paid_for_insurance | Claim_amount | City | Year | Month | Day | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23896 | C_CND_023897 | 2023-12-31 | Simi | Male | 761000 | Rabun Used Car Sales | Dodge | Viper | Double Overhead Camshaft | Auto | Red | 41000 | 85257-3102 | SUV | 8744249 | 2214 | 0.00 | Daugavpils | 2023 | 12 | 31 |
| 23897 | C_CND_023898 | 2023-12-31 | Simone | Male | 520000 | Progressive Shippers Cooperative Association No | Mercedes-B | E-Class | Double Overhead Camshaft | Auto | Red | 15000 | 53546-9427 | Sedan | 6819422 | 1178 | 0.00 | Ventspils | 2023 | 12 | 31 |
| 23898 | C_CND_023899 | 2023-12-31 | Skylar | Male | 530000 | Rabun Used Car Sales | Volvo | C70 | Overhead Camshaft | Manual | Pale White | 24000 | 85257-3102 | Hatchback | 6225183 | 1649 | 2400.00 | Liepaja | 2023 | 12 | 31 |
| 23899 | C_CND_023900 | 2023-12-31 | Yuna | Male | 13500 | U-Haul CO | Buick | Park Avenue | Double Overhead Camshaft | Auto | Pale White | 62000 | 78758-7841 | Hatchback | 8384785 | 3309 | 0.00 | Ventspils | 2023 | 12 | 31 |
| 23900 | C_CND_023901 | 2023-12-31 | Nathan | Female | 771000 | Buddy Storbeck's Diesel Service Inc | Ford | Contour | Double Overhead Camshaft | Auto | Red | 19000 | 06457-3834 | Sedan | 8170003 | 1036 | 0.00 | Jelgava | 2023 | 12 | 31 |
| 23901 | C_CND_023902 | 2023-12-31 | Martin | Male | 13500 | C & M Motors Inc | Plymouth | Voyager | Overhead Camshaft | Manual | Red | 12000 | 60504-7114 | Passenger | 8583598 | 692 | 1200.00 | Tukums | 2023 | 12 | 31 |
| 23902 | C_CND_023903 | 2023-12-31 | Jimmy | Female | 900000 | Ryder Truck Rental and Leasing | Chevrolet | Prizm | Double Overhead Camshaft | Auto | Black | 16000 | 06457-3834 | Hardtop | 7914229 | 1072 | 0.00 | Liepaja | 2023 | 12 | 31 |
| 23903 | C_CND_023904 | 2023-12-31 | Emma | Male | 705000 | Chrysler of Tri-Cities | BMW | 328i | Overhead Camshaft | Manual | Red | 21000 | 99301-3882 | Sedan | 7659127 | 1061 | 0.00 | Liepaja | 2023 | 12 | 31 |
| 23904 | C_CND_023905 | 2023-12-31 | Victoire | Male | 13500 | Chrysler Plymouth | Chevrolet | Metro | Double Overhead Camshaft | Auto | Black | 31000 | 53546-9427 | Passenger | 6030764 | 1922 | 3100.00 | Tukums | 2023 | 12 | 31 |
| 23905 | C_CND_023906 | 2023-12-31 | Donovan | Male | 1225000 | Pars Auto Sales | Lexus | ES300 | Double Overhead Camshaft | Auto | Pale White | 27500 | 38701-8047 | Hardtop | 7020564 | 1492 | 0.00 | Tukums | 2023 | 12 | 31 |